Top 5 Excel Formulas Every MIS Executive Must Know

By Excel With Lokesh

As an MIS Executive, your day revolves around Excel sheets. Whether you're generating sales reports or daily dashboards, mastering these 5 formulas will make your work faster and smarter.

1️⃣ VLOOKUP – Data Fetching from Tables  

=VLOOKUP("Product A", A2:D100, 3, FALSE)

🔹 Use it to pull data from master tables like price lists or employee data.

2️⃣ IF Statement – Apply Conditions in Reports

=IF(A2>100, "Above Target", "Below Target")

🔹 Commonly used for Pass/Fail, Bonus eligibility, or Status updates.

3️⃣ CONCATENATE / TEXTJOIN – Combine Text

=TEXTJOIN("",TRUE,A2,B2,C2)

🔹 Use it to merge first name, last name, and ID — ideal for creating codes.

4️⃣ COUNTIFS – Conditional Counting

=COUNTIFS(B2:B100, "East", C2:C100, "Completed")

🔹 Great for dashboard summaries — like region-wise status or task counts.

5️⃣ INDEX + MATCH – Dynamic Lookup (Better than VLOOKUP)

=INDEX(D2:D100, MATCH("Product X", A2:A100, 0))

🔹 More flexible & faster. VLOOKUP alternative for pro users.

🎯 Bonus Tip:

Use Excel Tables (Ctrl + T) to auto-expand formulas and improve formatting.